
create view [dbo].[tevopentransactions] as 
SELECT '' [TEID]
      ,''  [TETRANSISPENDING]
      ,'' [TETRANSTYPE]
      ,'' [TETRANSSTATUS]
      ,'' [TECUSTOMERID]
      ,'' [TETRANSDATE]
      ,'' [TEUSERID]
      ,'' [TEAUTHUSERID]
      ,'' [TETRANSNETAMOUNT]
      ,'' [TETRANSGROSSAMOUNT]
      ,'' [TETRANSPAYMENTAMOUNT]
      ,'' [TETRANSDISCPCT]
      ,'' [TETRANSDISCAMOUNT]
      ,'' [TETRANSLINEDISCAMOUNT]
      ,'' [TETRANSROUNDEDAMOUNT]
      ,'' [TETRANSISRETURNSALE]
      ,'' [TECURRENCYID]
      ,'' [TETRANSLOYALTYPOINTS]
      ,'' [TETRANSRECEIPTNUM]
      ,'' [TEACTIONID]
      ,'' [TEDOCTYPEID]
      ,'' [TETRANSSIGN]
      ,'' [TESTOREID]
      ,'' [TETERMINALID]
      ,'' [TEWHENINS]
      ,'' [TEWHENUPD]
      ,'' [TETRANSNUM]
      ,'' [TETRANSCOMMENT]
      ,'' [TEREVNUM]
      ,'' [TETRANSIPOSRECEIPTNUM]
      ,'' [TETRANSIPOSZNUM]
      ,'' [TESALESPERSONID]
      ,'' [TETRANSPREFIX]
      ,'' [TETRANSREFERENCEID]
      ,'' [TETRANSITTYPE]
      ,'' [TEDESTINATION]
      ,'' [TETRANSPORTPERPOSE]
      ,'' [TELOADPLACE]
      ,'' [TEAREAID]
      ,'' [TETABLENUMBER]
      ,'' [TETRANSISORDER]
      ,'' [TECANCELPOSID]
      ,'' [TECANCELDOCTYPEID]
      ,'' [TECANCELDOCPREFIX]
      ,'' [TECANCELDOCNUMBER]
      ,'' [TECANCELTRANSID]
      ,'' [TEREFPOSID]
      ,'' [TEREFDOCTYPEID]
      ,'' [TEREFDOCPREFIX]
      ,'' [TEREFDOCNUMBER]
      ,'' [TETRANSBOLOG]
      ,'' [TEORDERSTATUS]
      ,'' [TEDOWNLOADEDBY]
      ,'' [TETRANSALLINCLUSIVE]
      ,'' [TEREFALLINCLUSIVEID]
      ,'' [TECANCELPOSNAME]
      ,'' [TETRANSISESTIASIS]
      ,'' [TETRANSSOURCEREFERENCE]
      ,'' [TEESTIASISNUMTICKETS]
      ,'' [TEDELIVERYCHARGESTATUS]
      ,'' [TETRANSTRANSFERSTATUS]
      ,'' [TECHARGEID]
      ,'' [TEDESTINATIONSTORE]
      ,'' [TEREFISSUEREPLACEMENTLID]
      ,'' [TETRANSHASCHARGES]
      ,'' [TEAPPVERSION]
      ,'' [TETRANSDEFINESTATUSID]
      ,'' [TEOPOSMSRSCANINFO]
      ,'' [TECUSTALTADDRESSID]
      ,'' [TEDESTINATIONSTORELOCATION]
      ,'' [TECUSTPLATEID]
      ,'' [TETRANSSURCHARGESVATAMOUNT]
      ,'' [TETRANSSURCHARGESTOTAL]
      ,'' [TETRANSSURCHARGESVALUE]
      ,'' [TECUSTALTPHONEID]
      ,'' [TETRANSPDAMACHINEID]
      ,'' [TEITEMTICKETID]
      ,'' [TETRANSISURGENT]
      ,'' [TETRANSDAYMENUID]
      ,'' [TECUSTCONTACTID]
      ,'' [TETRANSLOYALTYPOINTSWIN]
      ,'' [TELOYALTYENABLED]
      ,'' [TETRANSATTR1]
      ,'' [TETRANSATTR2]
      ,'' [TETRANSATTRDECIMAL1]
      ,'' [TETRANSATTRDECIMAL2]
      ,'' [TETRANSATTRDATE1]
      ,'' [TETRANSATTRDATE2]
      ,'' [TETRANSATTRLOOKUPID1]
      ,'' [TETRANSATTRLOOKUPID2]
      ,'' [TETRANSSURPARTTOTAL]
      ,'' [TETRANSSURPARTVALUE]
      ,'' [TETRANSSURPARTVATAMOUNT]
      ,'' [TETRANSOFFICIALDATE]
      ,'' [TEPOSSERNUM]
      ,'' [TETRANSISSUM]
      ,'' [TETRANSBANKACCOUNTID]
      ,'' [TETRANSFUELCLASSCARDNUMBER]
      ,'' [TETRANSINCLUDEDINEXPORT]
      ,'' [TETRANSFUELDELIVERYID]
      ,'' [TETRANSFUELDROPID]
      ,'' [TEHOTELDEPARTMENTID]
      ,'' [TEHOTELRESERVATIONID]
      ,'' [TEHOTELGUESTID]
      ,'' [TEHOTELROOMID]
      ,'' [TEHOTELID]
      ,'' [TEHOTELROOMNO]
      ,'' [TETRANSPAYMENTCHANGED]
      ,'' [TETRANSBANKREPOSITORYNO]
      ,'' [TETRANSRELATEDDOCNO]
      ,'' [TETRANSPLATENUMBER]
      ,'' [TETRANSPREPAIDSTATUS]
      ,'' [TETRANSISEUROMAT]
      ,'' [TETRANSEUROMATSTATUS]
      ,'' [TETRANSEUROMATID]
      ,'' [TETRANSOPTID]
      ,'' [TETRANSOPTCOUPONNO]
      ,'' [TETRANSOPTAUTHID]
      ,'' [TETRANSOPTRECEIPTNO]
      ,'' [TETRANSTRANSPORTMEAN]
      ,'' [TETRANSDRIVERNAME]
      ,'' [TETRANSESTIASISPERSONSNUM]
      ,'' [TETRANSFORMTRANSID]
      ,'' [TESTOFAID]
      ,'' [TEHEATFUELSTATUS]
      ,'' [TEDELIVERYDATE]
      ,'' [TEDELIVERYDAYRANGE]
      ,'' [TEHEATFUELDOCTYPEID]
      ,'' [TEHEATFUELTENDERTYPEID]
      ,'' [TETRANSFUELPARKINGID]
      ,'' [TETRANSFUELPARKINGRECTABLE]
      ,'' [TETRANSFUELPARKINGARRIVALDATE]
      ,'' [TETRANSFUELPARKINGDEPARTUREDATE]
      ,'' [TETRANSFUELPARKINGCHARGEHOURS]
      ,'' [TEINITDOCTYPECODE]
      ,'' [TEINITDOCTYPENAME]
      ,'' [TEINITCUSTVAT]
      ,'' [TEINITCUSTNAME]
      ,'' [TEINITCUSTALTADDRESSDSCR]
      ,'' [TEINITCUSTPROFESSION]
      ,'' [TEINITCUSTADDRESS]
      ,'' [TEINITCUSTALTADDRESS]
      ,'' [TEINITCUSTCITY]
      ,'' [TEINITCUSTALTCITY]
      ,'' [TEINITCUSTCOUNTRY]
      ,'' [TEINITCUSTZIPCODE]
      ,'' [TEINITCUSTALTZIPCODE]
      ,'' [TEINITCUSTADDRESSAREA]
      ,'' [TEINITCUSTALTADDRESSAREA]
      ,'' [TEINITCUSTPREFECTURE]
      ,'' [TEINITCUSTALTPREFECTURE]
      ,'' [TEINITCUSTTAXOFFICENAME]
      ,'' [TEINITCUSTPHONE1]
      ,'' [TEINITCUSTALTPHONE1]
      ,'' [TEINITCUSTELECTRCOMPPAYCODE]
      ,'' [TEINITCUSTALTELECTRCOMPPAYCODE]
      ,'' [TEINITCUSTOILREGCODE]
      ,'' [TEINITCUSTALTOILREGCODE]
      ,'' [TEHEATDIESELDELIVERYNOTE]
      ,'' [TEHOTELBILLID]
      ,'' [TEHOTELBILLNO]
      ,'' [TEHOTELBILLNAME]
      ,'' [TEHOTELGROUPNAME]
      ,'' [TEHOTELGROUPCODE]
      ,'' [TEREPORTDATE]
      ,'' [TENONFISCALZ]
      ,'' [TEINITCUSTBALANCE]
      ,'' [TETRANSSFPSIGNATURE]
      ,'' [TETRANSLOYALTYSAMEWITHCUST]
      ,'' [TEEXTERNALTRANSID]
      ,'' [TETRANSFUELSUMDOCSTATUS]
      ,'' [TETRANSFUELSUMDOCREFID]
      ,'' [TEPOSMACHINEID]
      ,'' [TETRANSISNETLINK]
      ,'' [TETRANSDRYCLEANID]
      ,'' [TERETRIEVALORDERNUM]
      ,'' [TETRANSRECEIPTID]
      ,'' [TEISCONNECTORTRANS]
      ,'' [TETRANSBANKACCOUNTIBAN]
      ,'' [TETRANSAUTHCODE]
      ,'' [TETRANSNOTRANSFER]
      ,'' [TELOYALTYTRANSFERSTATUS]
      ,'' [TELOYALTYTRANSFERDATE]
      ,'' [TELOYALTYTRANSNUM]
      ,'' [TELOYALTYTRANSFERRETRIES]
      ,'' [TECUSTMEMBERCARDNO]
      ,'' [TEVATEXCLUSIONREASON]
      ,'' [TEIGNOREVATEXCLUSION]
      ,'' [TEVATEXCLUSIONID]
      ,'' [TEREDEEMEDLOYALTYPOINTS]
      ,'' [TECUSTMEMBERCARDID]
      ,'' [TEINTERNALTRANS]
      ,'' [TECPTASKLISTID]
      ,'' [TETRANSORDERNUM]
      ,'' [TEFUELTYPECODE]
      ,'' [TETRANSFUELNETVALUE]
      ,'' [TETRANSFUELALLTAXVALUE]
      ,'' [TEFROMSTORE]
      ,'' [TEFROMSTORELOCATION]
      ,'' [TELOCKEDPOSMACHINEID]
      ,'' [TELOCKEDDATETIME]
      ,'' [TEIGNOREEFKFUELEXCLUSION]
      ,'' [TEEFKFUELEXCLUSIONID]
      ,'' [TEEFKFUELEXCLUSIONREASON]
      ,'' [TEHOTELMEALPLANID]
      ,'' [TECOMPOSEDREFID]
      ,'' [TEMEALPLANPRICELISTID]
      ,'' [TEDELIVERYCHARGETIME]
      ,'' [TELASTESTIASISDISCOUNTPCT]
      ,'' [TEHOTELCASHONLY]
      ,'' [TETRANSFUELVATREGNO]
      ,'' [TEISSLAVEFAMILYCARD]
      ,'' [TEDELIVERYTENDERID]
      ,'' [TETRANSSFPQRCODE]
      ,'' [TEIMPORTTYPE]
      ,'' [TETRANSISEXPORTED]
      ,'' [TEPAXTERMINALID]
      ,'' [TETRANSFUELPUMPNO]
      ,'' [TEINITDOCTYPEID]
      ,'' [TEINITCUSTALLOWSUMTRANS]
      ,'' [TETRANSFERBODURATION]
      ,'' [TEEBOOKSSTATE]
      ,'' [TEEBOOKSMARK]
      ,'' [TEEBOOKSDELAYEDPROCESSCODE]
      ,'' [TEEBOOKSISEXPORTED]
      ,'' [TEEBOOKSUID]
      ,'' [TEEBOOKSERRORMESSAGE]
      ,'' [TELOYALTYCUSTOMERTIER]
      ,'' [TETRANSRELATEDID]
      ,'' [TETRANSSFPDESCRIPTION]
      ,'' [TEEBOOKSISCANCELEXPORTED]
      ,'' [TETRANSCOMMERCIALTRANSID]
      ,'' [TETRANSCUSTTIN]
      ,'' [TETRANSSUMMINMAX]
      ,'' [TETRANSSUMPREFIX]
      ,'' [TEVATEXCEMPTIONNO]
      ,'' [TEEFKEXCEMPTIONNO]
      ,'' [TEABCARDNO]
      ,'' [TEABPOINTSGIVEN]
      ,'' [TETRANSATTR3]
      ,'' [TETRANSATTR4]
      ,'' [TECARWASHEXITMOVEMENTID]
      ,'' [TECARWASHENTRYMOVEMENTID]
      ,'' [TEISBOUNDTOREMITTANCE]
         where 1 = 0 
GO


